Introduction
Spreadsheets
00:01:00:00
00:01:55:00
Hi, I'm
as a spreadsheet
H0001
00:03:39:00
you can use
way to others
C0001
Launch Excel
00:03:51:00
everything you do
that appears
H0002
00:04:22:00
click start, programs
hide the office assistant
M0001
Excel Workspace
00:06:12:00
now what you see
for the selection
M0002
00:06:36:00
the Excel grid
a productive tool
H0003
Entering Values
Text Values
00:06:51:00
00:07:14:00
in order to
an excel worksheet
H0004
00:08:10:00
start by selecting
are text values
M0003
Numeric Values
00:09:05:00
let's try entering
and press enter
M0004
AutoFill
00:10:00:00
when you have
are left aligned
M0005
Date Values
00:11:27:00
let's try adding
typed the value
M0006
Format Painter
00:12:22:00
Excel allows you
the format change
M0007
Formatting Dates
00:13:09:00
a date in excel
dates in cells
H0005
00:14:48:00
if you take
back into a date
M0008
Edit Cells
00:16:34:00
let's enter a couple
back to the cell
M0009
Sorting Lists
00:18:08:00
with values in a
sorting a list
M0010
00:18:49:00
when you enter
the selected range
H0006
Workbooks
Save
00:19:01:00
00:19:30:00
the grid in which
in excel
H0007
00:21:25:00
when you first
and save it
M0011
Open and Close
00:22:19:00
if you then
one workbook left
M0012
Find
00:24:02:00
here's a couple of
of the folder name
M0013
Favorites
00:25:00:00
If you do have
to that folder
M0014
Worksheets
00:27:12:00
within a workbook
most often
M0015
Manipulating Sheets
00:28:46:00
if you want to
this extra worksheet
M0016
00:29:24:00
a workbook gives you
changes to a workbook
H0008
Formatting Cells
Example
00:29:35:00
00:30:06:00
one of the really
at your company
H0009
00:30:30:00
here's an example
create this certificate
M0017
Enter Values
00:31:42:00
let me close
president below it
M0018
Modify Fonts
00:32:53:00
the first thing
new enlarged font size
M0019
Center Text
00:33:18:00
next let's center
this selected text
M0020
Font Size and Color
00:34:10:00
now let's make
color of the date
M0021
Format Date
00:35:10:00
we don't want
formatting to the date
M0022
Column Width
00:36:12:00
notice that excel
in that column
M0023
Formatting Techniques
Rows and Columns
00:36:34:00
in addition
wide border affect
H0010
00:37:57:00
let's create
all selected rows
M0024
Create Border
00:40:08:00
now select one
a signature row
M0025
Insert Columns
00:40:07:00
00:40:35:00
the certificate
above the signatures
H0011
00:41:28:00
first we need to
column border
M0026
Copy and Paste Cells
00:42:29:00
now we need to
signatures properly
M0027
Merge Cells
00:43:54:00
as you can see
the finished certificate
M0028
00:44:18:00
excel allows you
that selected range
H0012
Summarizing Numbers
Tab Entry
00:44:30:00
00:45:00:00
the original purpose
within the company
H0013
00:47:30:00
first name a new
within a grid
M0029
AutoSum
00:48:14:00
now we need
and the region
M0030
Grand Totals
00:50:40:00
now let's see
at this time
M0031
Custom Formulas
00:51:06:00
excel's autosum
of your own
H0014
00:53:46:00
suppose for example
a special need
M0032
00:54:14:00
Excel's autosum
in your spreadsheet
H0015
Formatting Numbers
Currency Style
00:01:21:00
once you've added
to interpret
H0016
00:02:05:00
suppose that you have
to other calls
M0033
Format Currency Style
00:03:45:00
notice that when you
number dialog box
M0034
AutoFormat Region
00:04:14:00
of the table
H0017
00:06:47:00
in the workbook
of their sections
M0035
Current Region
00:07:49:00
notice however
of more space
M0036
00:08:19:00
whenever you have
totals and headings
H0018
Creating Charts
Copy Worksheet
00:08:28:00
00:08:50:00
one of the most
how to do that
H0019
00:09:30:00
let's say that you
to be sales chart
M0037
Chart Wizard
00:10:34:00
we can delete
we'll look at later
M0038
Add to Chart
00:12:43:00
notice here that
and press delete
M0039
Chart Orientation
00:12:13:00
00:13:44:00
let's try a different
inappropriate orientation
M0040
Chart Type
00:14:02:00
even after you
you would like
H0020
00:14:57:00
on the charted
chart to look like
M0041
Chart Location
00:16:33:00
if you hold the mouse
to the table
M0042
00:16:58:00
charts in excel
the charting menu
H0021
Printing
Print Preview
00:17:10:00
00:17:46:00
then years ago
H0022
00:18:37:00
many times before
with the mouse pointer
M0043
Page Setup
00:20:06:00
directly from print
at the top
M0044
Margins
00:21:16:00
if you want
print preview itself
M0045
Page Layout
00:22:25:00
the problem with
to the workbook
M0046
Black & White Printing
00:23:15:00
on the sales
return to the workbook
M0047
View Multiple Sheets
00:24:00:00
so far each time
sheet in turn
M0048
Modify Multiple Sheets
00:24:47:00
even as you
one active sheet
M0049
Print Sheets
00:25:49:00
one thing you should
all of the sheets
M0050
Customizing Excel
Options
00:26:49:00
00:27:21:00
microsoft excel contains
it to work
H0023
00:28:45:00
many of the
default file location
M0051
Windows in Taskbar
00:29:28:00
back on the view menu
windows and taskbar optoin
M0052
Adaptive Menus
00:30:01:00
as you've noticed
for your use
H0024
00:30:03:00
00:30:54:00
to turn off
without having to pause
M0053
Toolbars
now let's look
frequently used commands
M0054
Context Toolbar
00:34:35:00
one other thing
context sensitive toolbar
M0055
00:35:26:00
menus are
that particular toolbar
H0025
Discovering More
Clues
00:36:00:00
00:36:22:00
excel has
about excel features
H0026
00:38:20:00
or hide different toolbars
M0056
Help
00:39:16:00
working in excel
M0057
Office Assistant
00:40:09:00
the office assistant
for the assistant
M0058
Expanded Help
00:41:11:00
let's go back
of related topics
M0059
Docking Help
00:42:11:00
even without
of your monitor
M0060
00:43:11:00
excel is
features themselves
H0027